home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vdailyriders.sql < prev    next >
Text File  |  2000-05-12  |  880b  |  24 lines
  1. CREATE OR REPLACE VIEW VDAILYRIDERS ( FAREBOX_GLID, 
  2. REPORT_DATE, COUNT_OF_AMOUNTS, TOT_AMT, AUTODUMP, 
  3. LOW, HIGH, DUMPUPR, AUTOHILODUMP, 
  4. BUS_ID, GARAGE_ID ) AS SELECT  
  5. FAREENTR.FAREBOX_GLID, TRUNC(FAREENTR.CONV_DATE) report_date,  
  6. COUNT(FAREENTR.AMOUNT) count_of_amounts,  
  7. SUM(FAREENTR.AMOUNT) tot_amt, SUM(FAREENTR.AUTO_DUMP) autodump, SUM(FAREENTR.LOW_FARE) low,  
  8. SUM(FAREENTR.HIGH_FARE) high , SUM(FAREENTR.DUMP_UPR) dumpupr,  
  9. SUM(FAREENTR.AUTO_DUMP + FAREENTR.LOW_FARE + FAREENTR.HIGH_FARE + FAREENTR.DUMP_UPR) autohilodump,  
  10. BUS.BUS_ID, GARAGE.GARAGE_ID  
  11. FROM  
  12. FAREENTR FAREENTR,  
  13. BUS BUS,  
  14. GARAGE GARAGE,  
  15. FAREBOX FAREBOX  
  16. WHERE  
  17. ( FAREENTR.FAREBOX_GLID=FAREBOX.GLID ) AND  
  18. ( BUS.GARAGEID=GARAGE.GLID ) AND  
  19. ( FAREBOX.LOCATION=BUS.GLID )  
  20. GROUP BY  
  21. TRUNC(FAREENTR.CONV_DATE),  
  22. BUS.BUS_ID, FAREENTR.FAREBOX_GLID, GARAGE.GARAGE_ID;
  23.  
  24.